SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Menbers](
	[MenberID] [int] IDENTITY(1,1) NOT NULL,
	[QQ] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IdentityCardAddress] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IdentityCardFront] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IdentityCardBack] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ZhifubaoAccountName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Photo] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Menbers] ON 

INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (1, N'54858', N'兰东才', N'福建武平', N'4e325ebdjw1e9h6hzz7c8j20c40ysq74.jpg', N'psb.jpg', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (4, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'家里房子装修预算.txt', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (5, N'55554', N'兰东才', N'福建武平', N' ', N' ', N'桃溪', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (6, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (7, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (8, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (9, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (10, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (11, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (12, N'1', N'兰东才', N'福建武平', N'psb.jpg', N'', N'桃溪', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (13, N'123456', N'1', N'1', N'psb.jpg', N'家里房子装修预算.txt', N'1', N'')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (15, N'111', N'111', N'111', N'System.Web.HttpPostedFile', N'System.Web.HttpPostedFile', N'111', N'System.Web.HttpPostedFile')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (16, N'11111', N'1', N'1', N' ', N' ', N'1', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (17, N'1', N'1', N'1', N'1_1.jpg', N'1_1.txt', N'1', N'1_1.xls')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (19, N'1q1', N'1', N'1', N'60d13638-c887-4ce3-b01c-55af4e83003d.jpg', N'8b7ced9f-e487-45b5-96f8-fb573151f97b.jpg', N'11111', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (20, N'a', N'a', N'a', N'2c6a54c9-5838-46e0-b419-e1a865ab497d.jpg', N'8dd6db1d-5e7a-4ce5-a6e8-2fae7cb219c7.txt', N'a', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (21, N'22222', N'222', N'22', N' ', N' ', N'22', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (22, N'q', N'11', N'11', N'24fbc3cb-ef1a-44f6-9026-788780214d1d.jpg', N' ', N'1', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (26, N'111111111', N'1', N'1', N' ', N' ', N'1', N' ')
INSERT [dbo].[Menbers] ([MenberID], [QQ], [Name], [IdentityCardAddress], [IdentityCardFront], [IdentityCardBack], [ZhifubaoAccountName], [Photo]) VALUES (27, N'88888', N'88888', N'8888', NULL, NULL, N'8888', NULL)
SET IDENTITY_INSERT [dbo].[Menbers] OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[ProjectFileds](
	[ProID] [int] IDENTITY(1,1) NOT NULL,
	[QQ] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Wangwang] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ZhifubaoAccount] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ZhifubaoName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[RebateZhifubao] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[RebateZhifubaoName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CaifutongAccount] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CaifutongName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ShopID] [int] NULL,
	[Cash] [money] NULL,
	[Cellphone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Fixphone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ReceiveName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ReceiveAddress] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ReceiveCellphone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ReceiveFixphone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Date] [datetime] NULL
) ON [PRIMARY]

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[QQRelation](
	[QQMappID] [int] IDENTITY(1,1) NOT NULL,
	[MainQQ] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[QQ] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[CreateTime] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[QQRelation] ON 

INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (2, N'222222', N'123456', N'Dec 12 2013 12:00AM')
INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (4, N'121231', N'123123', N'Oct 27 2013 12:00AM')
INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (5, N'2', N'2', N'Oct 27 2013 12:00AM')
INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (6, N'222', N'222', N'Oct 27 2013 12:00AM')
INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (7, N'1', N'2', N'Oct 27 2013 12:00AM')
INSERT [dbo].[QQRelation] ([QQMappID], [MainQQ], [QQ], [CreateTime]) VALUES (8, N'123456', N'654321', N'2013.10.25 12:00AM')
SET IDENTITY_INSERT [dbo].[QQRelation] OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Shops](
	[ShopID] [int] IDENTITY(1,1) NOT NULL,
	[ShopName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[ShopColor] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Shops] ON 

INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (1, N'浪迹天涯', N'#000000')
INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (4, N'店小二', N'#784512')
INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (5, N'GoodBoy', N'#FF9900')
INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (7, N'好孩子', N'#33FF00')
INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (9, N'下一站天后', N'#000000')
INSERT [dbo].[Shops] ([ShopID], [ShopName], [ShopColor]) VALUES (11, N'小欧够', N'#FF0000')
SET IDENTITY_INSERT [dbo].[Shops] OFF
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [dbo].[Users](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Password] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[IsAdmin] [bit] NULL,
	[ContainsProFileds] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

SET IDENTITY_INSERT [dbo].[Users] ON 

INSERT [dbo].[Users] ([UserID], [UserName], [Password], [IsAdmin], [ContainsProFileds]) VALUES (1, N'Lanny', N'123456', 0, N'"QQ":"1","Wangwang":"0","ZhifubaoAccount":"0","ZhifubaoName":"0","RebateZhifubao":"0","RebateZhifubaoName":"0","CaifutongAccount":"1","CaifutongName":"0","ShopID":"0","Cash":"0","Cellphone":"0","Fixphone":"0","ReceiveName":"0","ReceiveAddress":"0","ReceiveCellphone":"0","ReceiveFixphone":"0","Date":"0"')
SET IDENTITY_INSERT [dbo].[Users] OFF
